'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object

'Usage
 
Dim instance As CalcSubstituteFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)

public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 3 - 4 items: text, old_text, new_text, [instance_num].

Text is the text or the reference to a cell containing text for which you want to substitute characters.

Old_text is the text you want to replace.

New_text is the text you want to replace old_text with.

[Instance_num] specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.

Return Value

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

CalcSubstituteFunction Class
CalcSubstituteFunction Members
Overload List